Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


  

PreviousPrevious NextNext

RE: Compare 2 dates
~Umberto Nongeroson 24.Dec.03 02:34 PM a Web browser
Domino Designer 6.0.1 All Platforms


First, you need to find out exactly what value -- and what datatype of value -- is in that field. Use the Document Properties dialog from a view to examine the field value.

Rod's formula looks OK to me -- it assumes that dates are formatted dd/mm/yyyy on your computer, but based on your original posting it looks like they are. Are you sure you didn't leave out the square brackets or anything?

You might try putting in some debugging code so that you can tell which part of the expression is failing. E.g.:

@StatusBar("@IsTime(supplier_ETD) = " + @Text(@IsTime(supplier_ETD)))

Also, you said that it's a "computed" field. Did you know that computed fields are not recalculated when opening an existing document? Only when you edit the document, and refresh or save it, will Notes display a new value. The debugging code will also help you to determine when the formula is actually being evaluated.




Compare 2 dates (~Maria Prerever... 24.Dec.03)
. . RE: Compare 2 dates (~Holly Nimapule... 24.Dec.03)
. . . . RE: Compare 2 dates (~Maria Prerever... 24.Dec.03)
. . . . . . RE: Compare 2 dates (~Holly Nimapule... 26.Dec.03)
. . RE: Compare 2 dates (~Kirk Elreterod... 24.Dec.03)
. . . . RE: Compare 2 dates (~Maria Prerever... 24.Dec.03)
. . . . . . RE: Compare 2 dates (~Bill Frokimari... 24.Dec.03)


Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS